home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Netware Super Library
/
Netware Super Library.iso
/
btrieve
/
btfiler
/
pol.inx
< prev
next >
Wrap
Text File
|
1992-08-21
|
4KB
|
126 lines
#
# This line, and all lines beginning with '#' are comments
#
# This file will allow you to import and export data from Btrieve
# files in a variety of ways. Since you define what fields are in
# or should be written to the ASCII comma delimited file, you can
# do some pretty neat stuff, like eliminating fields from data
# files by exporting only what you really want and importing to a
# new file the selected fields.
#
# The format of the information for each field is as follows:
#
# FIELD NAME=s
# BTRIEVE START=n
# BTRIEVE LEN=n
# FIELD TYPE=s
# ASCII LEN=n
# ASCII DECIMALS=n
#
# 'FIELD NAME' is essentially a comment for now.
#
# 'BTRIEVE START' is the position within the Btrieve file where
# this field is (or in the case of import, where the data should
# go). The first position in the file is 1.
#
# 'BTRIEVE LEN' is the length of the field in the Btrieve fle in
# it's native format. Note, for instance, that Btrieve DATE fields
# are 4 bytes.
#
# 'FIELD TYPE' is one of the following:
#
# "String"
# "Integer"
# "Float"
# "Date"
# "Time"
# "Decimal"
# "Money"
# "Logical"
# "Numeric"
# "Bfloat"
# "Lstring"
# "Zstring"
# "Unsigned Binary"
# "Autoincrement"
# "Pascal Real"
#
# NOTE: Only meaningful for IMPORT is a fieldtype of IGNORE. What this
# does is ignore the field in the ASCII comma-delimited file. This
# allows you to import files that have fields that you do not wish
# to import.
#
# ASCII LEN' is the length the field should take in the ASCII
# file.
#
# ASCII DECIMALS is only meaningful for numbers. N/A if it does not apply.
#
# The ASCII output file will look something like this:
#
# "Jones ","Bob ","404 Midstreams Road","Brick","NJ","08724"
#
# In the above case, the first 5 fields might have been STRING fields,
# and the last field might have been Numeric, Decimal, or Integer.
#
# Field 1
#
FIELD NAME=POL-PO Num
BTRIEVE START=1
BTRIEVE LEN=6
FIELD TYPE=string
ASCII LEN=6
ASCII DECIMALS=N/A
#
# Field 2
#
FIELD NAME=POL-Sequence
BTRIEVE START=7
BTRIEVE LEN=3
FIELD TYPE=string
ASCII LEN=3
ASCII DECIMALS=N/A
#
# Field 3
#
FIELD NAME=POL-SKU
BTRIEVE START=10
BTRIEVE LEN=7
FIELD TYPE=string
ASCII LEN=7
ASCII DECIMALS=N/A
#
# Field 4
#
FIELD NAME=POL-Unit Retail
BTRIEVE START=17
BTRIEVE LEN=5
FIELD TYPE=decimal
ASCII LEN=10
ASCII DECIMALS=2
#
# Field 5
#
FIELD NAME=POL-Cost
BTRIEVE START=22
BTRIEVE LEN=5
FIELD TYPE=decimal
ASCII LEN=10
ASCII DECIMALS=2
#
# Field 6
#
FIELD NAME=POL-Ord Qty
BTRIEVE START=93
BTRIEVE LEN=4
FIELD TYPE=decimal
ASCII LEN=10
ASCII DECIMALS=0
#
# This is just a demo. Lots of fields follow, we just
# picked these to extract. Note that field 6 is not
# adjacent to field 5. The order that the fields are
# defined dictates their order in the export file, or
# in the case of imports, the fields must be defined in
# the order the fields appear in the import file.
#